create or replace trigger trg_projects
  before insert on projects
  for each row
begin
  SELECT seq_projects.nextval into :new.id from dual;
end trg_projects;
/
